package com.hfut.manage.mapper;

import com.hfut.manage.pojo.Teacher;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.mapping.StatementType;

import java.util.List;
import java.util.Map;


public interface TeacherMapper extends BaseMapper<Teacher> {
    @Select("{call GetTeacherCountByDeptAndTitle()}")
    @Options(statementType = StatementType.CALLABLE)
    List<Map<String, Object>> callTeacherStatsProcedure();
}
